﻿/********************************************************************************************************************
* Author:	Christos Polydorou																						*
* Email:	std04237@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_userActivate" that activates a new 	*
*			user.																									*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_userActivate]
	@username nvarchar(50)
AS
	BEGIN
		UPDATE Users
		SET IsEnabled = '1'
		WHERE Users.username = @username
	END
RETURN 0